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