UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D27ZRewJeUFLsD8m67s4U4PzPoY8zYfWtv99kd14pBg='
WHERE
key_id = 'c360718304ac969543474f654d614cf60cbe1e8e3e912bd04d68253ce4a28346'
AND (
token = 'D27ZRewJeUFLsD8m67s4U4PzPoY8zYfWtv99kd14pBg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)