UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nnTSCbNBwgQUbjwKxDm4mY3CEHwk1PnEecHvrlwWHOE='
WHERE
key_id = 'd3c28e31f90ac71430af58ead199fb8c44b41e61a45e25f02d3678dab891c12f'
AND (
token = 'nnTSCbNBwgQUbjwKxDm4mY3CEHwk1PnEecHvrlwWHOE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)