UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '65p85rPHhgb88ZXHx/9uefGuXhNUs+ehIFC+NGTEd2A='
WHERE
key_id = '1a6ae22a288ea145034273f8659d2f7398bcdefc9b01c55081e189cbcc3591af'
AND (
token = '65p85rPHhgb88ZXHx/9uefGuXhNUs+ehIFC+NGTEd2A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)