UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DJrz+KlvIuY4XdtR7TAa6M78utR6lK9n9+rBE80FAWM='
WHERE
key_id = 'a4dba260007dcadea84666c8bfd4597dbc8344ca68e62234f5a87116d5bef615'
AND (
token = 'DJrz+KlvIuY4XdtR7TAa6M78utR6lK9n9+rBE80FAWM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)