UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pf0L2P9TcyiopUl6ahC+kLvesuhjQSO19MUHxVZN8xk='
WHERE
key_id = '045ae38dd07753b2b3646a53aef41a6ad9665998d39f7d2201da1a0022fbdf36'
AND (
token = 'pf0L2P9TcyiopUl6ahC+kLvesuhjQSO19MUHxVZN8xk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)