UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J+tvxbmrnm07TweAj2UUmJY149DiGWn+/+jlzzoZYmw='
WHERE
key_id = '6ec0d6bc8451e68b4cce8ee45806e16c2035a0da64555de0e38179ba6075fc70'
AND (
token = 'J+tvxbmrnm07TweAj2UUmJY149DiGWn+/+jlzzoZYmw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)