UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z/l+syHzEs9rGqmvC8nIsD1oFbDRCVFmtjV0CANLUdU='
WHERE
key_id = '2406e7e4ef631042337190fcef8c2c848d58228be1572097f9311defa73b2b9f'
AND (
token = 'Z/l+syHzEs9rGqmvC8nIsD1oFbDRCVFmtjV0CANLUdU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)