UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u0e8KlrVwNjcss5rIbNSVOgjyymXiuoJoYfX43BruYI='
WHERE
key_id = '6a422326f83cd74bde2fcb4a41895726407c1288e3bc5ac4fcf37366c516c5ca'
AND (
token = 'u0e8KlrVwNjcss5rIbNSVOgjyymXiuoJoYfX43BruYI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)