UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BLuuzCsyju5uCwtu1UKRW4LKpoHKFwueJF2OmgHyrJ4='
WHERE
key_id = '588d5b3243cf288a01754cddedb25dd0fe74ab5a3c7aa5d5481ec31f90ff9397'
AND (
token = 'BLuuzCsyju5uCwtu1UKRW4LKpoHKFwueJF2OmgHyrJ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)