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