UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lQfAjOOin2a5KYCjEKV7m+yDpHv+i91tukt+lMoLIfQ='
WHERE
key_id = 'cec277bddc5af1923093ba88988b5a72cb66de0fee69d6526e2050cd04738bf2'
AND (
token = 'lQfAjOOin2a5KYCjEKV7m+yDpHv+i91tukt+lMoLIfQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)