UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YZ4jeT6YTDXUZ7qaRhYFja0fE/udaSkv6nN8XvmvbEI='
WHERE
key_id = 'a0e0b4b8e58d2efe84fd8daa954a87f5795497b4c34f17f52c23c80e83ae5ad1'
AND (
token = 'YZ4jeT6YTDXUZ7qaRhYFja0fE/udaSkv6nN8XvmvbEI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)