UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HsSXE+VNBNTq5zVNly52XGqdSB/FfEtO0/JLViYBJcE='
WHERE
key_id = '7dd3a937c23e45d2f81ab554ff61404a2bf291b2cef32070dae56643375a1150'
AND (
token = 'HsSXE+VNBNTq5zVNly52XGqdSB/FfEtO0/JLViYBJcE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)