UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aAkgrs9LUR39vjDy2w6ZOtr4MifxGb+CuT31sT5RQgs='
WHERE
key_id = '5f563bea52cb3cda6acc8ea659a967109de8668b7187ecbfc2b7e4dcf4e98a9e'
AND (
token = 'aAkgrs9LUR39vjDy2w6ZOtr4MifxGb+CuT31sT5RQgs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)