UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sPI2Hx6HPVmpTT+7mFJRSzmg0bNrRUOCpLsjnMcJLB4='
WHERE
key_id = 'aff290624c011b9a694fe8eaab8134d2e49ba962f6f9bbfaa9f1bd45333995b0'
AND (
token = 'sPI2Hx6HPVmpTT+7mFJRSzmg0bNrRUOCpLsjnMcJLB4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)