UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cPxzFW3VxXn1v1wHsxpHPkYuyhne4n0sLaG7g0xsxjE='
WHERE
key_id = '465fc6b7ea84a40c004309d77c8df3d37a9a5c2d8f10a5e01a29903954c87f02'
AND (
token = 'cPxzFW3VxXn1v1wHsxpHPkYuyhne4n0sLaG7g0xsxjE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)