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