UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KKxJcFYDLEbcLpN7X43SHA1oPqGKWKHwxO3OCj+yVA4='
WHERE
key_id = '2ca90a180b42a87292f6aff6a3a1018a51d1a312a8d8c1f291df2411bffcb426'
AND (
token = 'KKxJcFYDLEbcLpN7X43SHA1oPqGKWKHwxO3OCj+yVA4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)