UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pgLG3z3SziwNQp6N3MKnbuFPkuKPuIlk8M/ty0XhJXc='
WHERE
key_id = '542e71214ab240bca682ff8422d45f8ee1e23b3ea8627d579f8b6aafdf393ae0'
AND (
token = 'pgLG3z3SziwNQp6N3MKnbuFPkuKPuIlk8M/ty0XhJXc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)