UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EceYhJ7D/v2LszGjCzsEy2/EIFDWZ0YAqFUrZ1bC/PE='
WHERE
key_id = 'a24b274f829b05e99782b02d4bfd8c5325d2f13cc2e0b304aff9c2bbc43e78cd'
AND (
token = 'EceYhJ7D/v2LszGjCzsEy2/EIFDWZ0YAqFUrZ1bC/PE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)