UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X0CJ7TNB+iB+066IYTQrJEsftoK6IGPCTdgqOG6jNtA='
WHERE
key_id = '52f90b4b8d611c7d8519adc36404b570d9fb499284564ce8e49ea09ee077b4b4'
AND (
token = 'X0CJ7TNB+iB+066IYTQrJEsftoK6IGPCTdgqOG6jNtA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)