UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/sRDQRjdujzBU8dooANHJKWSacd75N3tZdjvgvUlz/c='
WHERE
key_id = '1af8ca5d4eb1920b302296dc46bfa79836567abd4ff2218071b7a42890338ab5'
AND (
token = '/sRDQRjdujzBU8dooANHJKWSacd75N3tZdjvgvUlz/c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)