UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8jhmbMBPUChHu6fCIlhfm1i6+YoftMjtIDEO4rWLmX4='
WHERE
key_id = 'a1a87fa3fa582817af1d445122d51eaecf2d848df23ee7a5327b5094dae90797'
AND (
token = '8jhmbMBPUChHu6fCIlhfm1i6+YoftMjtIDEO4rWLmX4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)