UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S7W4JsKcTBPlkiwRzybek6poLfC3zBx3zJXdWOUJcKo='
WHERE
key_id = '4c25563d2231e9a590494502a3e6ab371dddfe2eb31e8dc7831a0ce94b6b0b32'
AND (
token = 'S7W4JsKcTBPlkiwRzybek6poLfC3zBx3zJXdWOUJcKo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)