UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M7zjr2slvhcG9GsoO5cFDgiUSx85YI5wiU+G7TDFiWA='
WHERE
key_id = '81f55e2d3c9407141a73c16188192f4b8ff128896af9a99df8e09b8110836ee4'
AND (
token = 'M7zjr2slvhcG9GsoO5cFDgiUSx85YI5wiU+G7TDFiWA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)