UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7mfQ9GkJGStroWSwiLuipqTAqCJi/8ll2DhHDv21AgQ='
WHERE
key_id = 'e934795b09faac8fec0a116e63df957d6b408f70ae308ab28af3e07cea011ba3'
AND (
token = '7mfQ9GkJGStroWSwiLuipqTAqCJi/8ll2DhHDv21AgQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)