UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W3iohIuIrga3dd/8Ypgw7aFTFTx1SCNBNICTJycjbDk='
WHERE
key_id = '2c7190426a87cdf658589bf7e3519486241f0b52ee352efe8d2858393211427e'
AND (
token = 'W3iohIuIrga3dd/8Ypgw7aFTFTx1SCNBNICTJycjbDk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)