UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xKCXjMQEMtc5u0chEBa4Vu6ltLZfo0GniGF85qvNC34='
WHERE
key_id = '50faf38b7ffad08e9a63e5454ce7fb71c5c05cb3bed95d7ec05c451fcb0ba992'
AND (
token = 'xKCXjMQEMtc5u0chEBa4Vu6ltLZfo0GniGF85qvNC34='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)