UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ta+2eyHP5VAdNYkSyis6W6Xohg9jEVfUt59x0YULbS4='
WHERE
key_id = 'd4e056e16be463929867ac3ec502703d2ae3fd0ef92ab71aac27c9b3bdf1ef86'
AND (
token = 'ta+2eyHP5VAdNYkSyis6W6Xohg9jEVfUt59x0YULbS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)