UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/8v5EOZIZkNbo1s650g1M5hmH5vsV9vb5xNcG0xQCyc='
WHERE
key_id = '562acdae8f723d76f60a9ceb5e55003c3e1b8b17d86f75939532a954b9f4c2b9'
AND (
token = '/8v5EOZIZkNbo1s650g1M5hmH5vsV9vb5xNcG0xQCyc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)