UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XGihtcCZvotOsjqCJF3GfcPJNEi2s7csatzTHMcLdgw='
WHERE
key_id = '1cef1088d5eae3b34b5841e671ca7091aa4cc4597512ed665a3bc26f868f54bb'
AND (
token = 'XGihtcCZvotOsjqCJF3GfcPJNEi2s7csatzTHMcLdgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)