UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pCQWfqtip0hnO8krFceThvpbrj+Huv/8GQ/5JHYi9uM='
WHERE
key_id = 'a7d77af5924a04db37429dc274a74bd9a5af9a5e3da865dbf74c65e1f321c7ba'
AND (
token = 'pCQWfqtip0hnO8krFceThvpbrj+Huv/8GQ/5JHYi9uM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)